Dataset statistics
| Number of variables | 20 |
|---|---|
| Number of observations | 8827 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 1.3 MiB |
| Average record size in memory | 153.0 B |
Variable types
| Text | 3 |
|---|---|
| Numeric | 4 |
| Categorical | 11 |
| DateTime | 1 |
| Boolean | 1 |
card_number is highly overall correlated with customer_segment and 3 other fields | High correlation |
customer_segment is highly overall correlated with card_number | High correlation |
card_type is highly overall correlated with card_number | High correlation |
customer_location is highly overall correlated with card_number and 1 other fields | High correlation |
trans_loc is highly overall correlated with card_number and 1 other fields | High correlation |
trans_id has unique values | Unique |
trans_approval_code has unique values | Unique |
Reproduction
| Analysis started | 2023-09-09 00:49:34.707259 |
|---|---|
| Analysis finished | 2023-09-09 00:50:40.987642 |
| Duration | 1 minute and 6.28 seconds |
| Software version | ydata-profiling vv4.5.1 |
| Download configuration | config.json |
cardholder_name
Text
| Distinct | 498 |
|---|---|
| Distinct (%) | 5.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 69.1 KiB |
Length
| Max length | 23 |
|---|---|
| Median length | 20 |
| Mean length | 13.243004 |
| Min length | 8 |
Characters and Unicode
| Total characters | 116896 |
|---|---|
| Distinct characters | 51 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Andrea Hess |
|---|---|
| 2nd row | Andrea Hess |
| 3rd row | Andrea Hess |
| 4th row | Andrea Hess |
| 5th row | Andrea Hess |
| Value | Count | Frequency (%) |
| michael | 215 | 1.2% |
| williams | 205 | 1.1% |
| jones | 192 | 1.1% |
| smith | 182 | 1.0% |
| johnson | 168 | 0.9% |
| john | 160 | 0.9% |
| brown | 160 | 0.9% |
| ashley | 145 | 0.8% |
| melissa | 143 | 0.8% |
| taylor | 124 | 0.7% |
| Other values (545) | 16306 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 10934 | 9.4% |
| a | 10314 | 8.8% |
| 9173 | 7.8% | |
| n | 9168 | 7.8% |
| r | 8467 | 7.2% |
| i | 6956 | 6.0% |
| o | 6283 | 5.4% |
| l | 6120 | 5.2% |
| s | 5582 | 4.8% |
| h | 4127 | 3.5% |
| Other values (41) | 39772 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 89304 | |
| Uppercase Letter | 18197 | 15.6% |
| Space Separator | 9173 | 7.8% |
| Other Punctuation | 222 | 0.2% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 10934 | |
| a | 10314 | |
| n | 9168 | |
| r | 8467 | |
| i | 6956 | 7.8% |
| o | 6283 | 7.0% |
| l | 6120 | 6.9% |
| s | 5582 | 6.3% |
| h | 4127 | 4.6% |
| t | 3720 | 4.2% |
| Other values (16) | 17633 |
Uppercase Letter
| Value | Count | Frequency (%) |
| M | 2022 | 11.1% |
| J | 1820 | 10.0% |
| C | 1424 | 7.8% |
| S | 1247 | 6.9% |
| A | 1146 | 6.3% |
| D | 1061 | 5.8% |
| B | 1059 | 5.8% |
| W | 1054 | 5.8% |
| K | 956 | 5.3% |
| R | 950 | 5.2% |
| Other values (13) | 5458 |
Space Separator
| Value | Count | Frequency (%) |
| 9173 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 222 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 107501 | |
| Common | 9395 | 8.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 10934 | 10.2% |
| a | 10314 | 9.6% |
| n | 9168 | 8.5% |
| r | 8467 | 7.9% |
| i | 6956 | 6.5% |
| o | 6283 | 5.8% |
| l | 6120 | 5.7% |
| s | 5582 | 5.2% |
| h | 4127 | 3.8% |
| t | 3720 | 3.5% |
| Other values (39) | 35830 |
Common
| Value | Count | Frequency (%) |
| 9173 | ||
| . | 222 | 2.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 116896 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 10934 | 9.4% |
| a | 10314 | 8.8% |
| 9173 | 7.8% | |
| n | 9168 | 7.8% |
| r | 8467 | 7.2% |
| i | 6956 | 6.0% |
| o | 6283 | 5.4% |
| l | 6120 | 5.2% |
| s | 5582 | 4.8% |
| h | 4127 | 3.5% |
| Other values (41) | 39772 |
card_number
Real number (ℝ)
HIGH CORRELATION
| Distinct | 500 |
|---|---|
| Distinct (%) | 5.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.0232185 × 1011 |
| Minimum | 6.8775423 × 108 |
|---|---|
| Maximum | 9.9830793 × 1011 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 69.1 KiB |
Quantile statistics
| Minimum | 6.8775423 × 108 |
|---|---|
| 5-th percentile | 5.6516319 × 1010 |
| Q1 | 2.5897226 × 1011 |
| median | 4.9406557 × 1011 |
| Q3 | 7.3950696 × 1011 |
| 95-th percentile | 9.4976373 × 1011 |
| Maximum | 9.9830793 × 1011 |
| Range | 9.9762018 × 1011 |
| Interquartile range (IQR) | 4.805347 × 1011 |
Descriptive statistics
| Standard deviation | 2.8029156 × 1011 |
|---|---|
| Coefficient of variation (CV) | 0.55799198 |
| Kurtosis | -1.1257441 |
| Mean | 5.0232185 × 1011 |
| Median Absolute Deviation (MAD) | 2.3750417 × 1011 |
| Skewness | 0.027604481 |
| Sum | 4.433995 × 1015 |
| Variance | 7.8563361 × 1022 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 2.648952136 × 1011 | 24 | 0.3% |
| 1.318558329 × 1011 | 24 | 0.3% |
| 6.20106724 × 1011 | 24 | 0.3% |
| 1.254398601 × 1011 | 24 | 0.3% |
| 4.072110048 × 1011 | 24 | 0.3% |
| 4.215858386 × 1011 | 24 | 0.3% |
| 9.526770655 × 1011 | 24 | 0.3% |
| 4.321999211 × 1011 | 24 | 0.3% |
| 7.168650139 × 1011 | 24 | 0.3% |
| 1.491716627 × 1011 | 24 | 0.3% |
| Other values (490) | 8587 |
| Value | Count | Frequency (%) |
| 687754227 | 14 | |
| 1660512712 | 18 | |
| 4440579128 | 17 | |
| 6927126924 | 14 | |
| 7390485495 | 12 | |
| 1.31270111 × 1010 | 15 | |
| 1.588174266 × 1010 | 22 | |
| 1.690193362 × 1010 | 20 | |
| 1.875705705 × 1010 | 14 | |
| 2.194776567 × 1010 | 21 |
| Value | Count | Frequency (%) |
| 9.98307935 × 1011 | 22 | |
| 9.975805694 × 1011 | 21 | |
| 9.95990208 × 1011 | 23 | |
| 9.949190434 × 1011 | 15 | |
| 9.94746664 × 1011 | 18 | |
| 9.92545598 × 1011 | 15 | |
| 9.893812544 × 1011 | 15 | |
| 9.876034547 × 1011 | 15 | |
| 9.854507522 × 1011 | 12 | |
| 9.854390367 × 1011 | 12 |
customer_age
Real number (ℝ)
| Distinct | 48 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 43.598505 |
| Minimum | 18 |
|---|---|
| Maximum | 69 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 69.1 KiB |
Quantile statistics
| Minimum | 18 |
|---|---|
| 5-th percentile | 20 |
| Q1 | 30 |
| median | 43 |
| Q3 | 56 |
| 95-th percentile | 67 |
| Maximum | 69 |
| Range | 51 |
| Interquartile range (IQR) | 26 |
Descriptive statistics
| Standard deviation | 15.1068 |
|---|---|
| Coefficient of variation (CV) | 0.34649812 |
| Kurtosis | -1.1938139 |
| Mean | 43.598505 |
| Median Absolute Deviation (MAD) | 13 |
| Skewness | -0.024435269 |
| Sum | 384844 |
| Variance | 228.2154 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=48)
| Value | Count | Frequency (%) |
| 36 | 394 | 4.5% |
| 60 | 371 | 4.2% |
| 47 | 331 | 3.7% |
| 39 | 325 | 3.7% |
| 43 | 321 | 3.6% |
| 51 | 318 | 3.6% |
| 26 | 315 | 3.6% |
| 67 | 294 | 3.3% |
| 50 | 291 | 3.3% |
| 29 | 283 | 3.2% |
| Other values (38) | 5584 |
| Value | Count | Frequency (%) |
| 18 | 239 | |
| 19 | 143 | |
| 20 | 157 | |
| 21 | 190 | |
| 22 | 211 | |
| 23 | 154 | |
| 25 | 192 | |
| 26 | 315 | |
| 27 | 108 | 1.2% |
| 28 | 149 |
| Value | Count | Frequency (%) |
| 69 | 237 | |
| 68 | 14 | 0.2% |
| 67 | 294 | |
| 66 | 214 | |
| 65 | 38 | 0.4% |
| 64 | 187 | |
| 63 | 264 | |
| 62 | 86 | 1.0% |
| 61 | 241 | |
| 60 | 371 |
customer_segment
Categorical
HIGH CORRELATION
| Distinct | 5 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 69.1 KiB |
| Premium | |
|---|---|
| Business | |
| Other | |
| Student | |
| Retail |
Length
| Max length | 8 |
|---|---|
| Median length | 7 |
| Mean length | 6.6101733 |
| Min length | 5 |
Characters and Unicode
| Total characters | 58348 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Premium |
|---|---|
| 2nd row | Premium |
| 3rd row | Premium |
| 4th row | Premium |
| 5th row | Premium |
Common Values
| Value | Count | Frequency (%) |
| Premium | 1881 | |
| Business | 1822 | |
| Other | 1806 | |
| Student | 1667 | |
| Retail | 1651 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| premium | 1881 | |
| business | 1822 | |
| other | 1806 | |
| student | 1667 | |
| retail | 1651 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 8827 | |
| t | 6791 | |
| s | 5466 | |
| u | 5370 | |
| i | 5354 | |
| m | 3762 | 6.4% |
| r | 3687 | 6.3% |
| n | 3489 | 6.0% |
| P | 1881 | 3.2% |
| B | 1822 | 3.1% |
| Other values (7) | 11899 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 49521 | |
| Uppercase Letter | 8827 | 15.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 8827 | |
| t | 6791 | |
| s | 5466 | |
| u | 5370 | |
| i | 5354 | |
| m | 3762 | |
| r | 3687 | |
| n | 3489 | 7.0% |
| h | 1806 | 3.6% |
| d | 1667 | 3.4% |
| Other values (2) | 3302 | 6.7% |
Uppercase Letter
| Value | Count | Frequency (%) |
| P | 1881 | |
| B | 1822 | |
| O | 1806 | |
| S | 1667 | |
| R | 1651 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 58348 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 8827 | |
| t | 6791 | |
| s | 5466 | |
| u | 5370 | |
| i | 5354 | |
| m | 3762 | 6.4% |
| r | 3687 | 6.3% |
| n | 3489 | 6.0% |
| P | 1881 | 3.2% |
| B | 1822 | 3.1% |
| Other values (7) | 11899 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 58348 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 8827 | |
| t | 6791 | |
| s | 5466 | |
| u | 5370 | |
| i | 5354 | |
| m | 3762 | 6.4% |
| r | 3687 | 6.3% |
| n | 3489 | 6.0% |
| P | 1881 | 3.2% |
| B | 1822 | 3.1% |
| Other values (7) | 11899 |
card_type
Categorical
HIGH CORRELATION
| Distinct | 5 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 69.1 KiB |
| Other | |
|---|---|
| Rupay | |
| American Express | |
| MasterCard | |
| Visa |
Length
| Max length | 16 |
|---|---|
| Median length | 10 |
| Mean length | 7.9220573 |
| Min length | 4 |
Characters and Unicode
| Total characters | 69928 |
|---|---|
| Distinct characters | 23 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Other |
|---|---|
| 2nd row | Other |
| 3rd row | Other |
| 4th row | Other |
| 5th row | Other |
Common Values
| Value | Count | Frequency (%) |
| Other | 1904 | |
| Rupay | 1852 | |
| American Express | 1730 | |
| MasterCard | 1684 | |
| Visa | 1657 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| other | 1904 | |
| rupay | 1852 | |
| american | 1730 | |
| express | 1730 | |
| mastercard | 1684 | |
| visa | 1657 |
Most occurring characters
| Value | Count | Frequency (%) |
| r | 8732 | 12.5% |
| a | 8607 | 12.3% |
| e | 7048 | 10.1% |
| s | 6801 | 9.7% |
| t | 3588 | 5.1% |
| p | 3582 | 5.1% |
| i | 3387 | 4.8% |
| O | 1904 | 2.7% |
| h | 1904 | 2.7% |
| R | 1852 | 2.6% |
| Other values (13) | 22523 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 55957 | |
| Uppercase Letter | 12241 | 17.5% |
| Space Separator | 1730 | 2.5% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| r | 8732 | |
| a | 8607 | |
| e | 7048 | |
| s | 6801 | |
| t | 3588 | |
| p | 3582 | |
| i | 3387 | 6.1% |
| h | 1904 | 3.4% |
| u | 1852 | 3.3% |
| y | 1852 | 3.3% |
| Other values (5) | 8604 |
Uppercase Letter
| Value | Count | Frequency (%) |
| O | 1904 | |
| R | 1852 | |
| E | 1730 | |
| A | 1730 | |
| M | 1684 | |
| C | 1684 | |
| V | 1657 |
Space Separator
| Value | Count | Frequency (%) |
| 1730 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 68198 | |
| Common | 1730 | 2.5% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| r | 8732 | |
| a | 8607 | |
| e | 7048 | 10.3% |
| s | 6801 | 10.0% |
| t | 3588 | 5.3% |
| p | 3582 | 5.3% |
| i | 3387 | 5.0% |
| O | 1904 | 2.8% |
| h | 1904 | 2.8% |
| R | 1852 | 2.7% |
| Other values (12) | 20793 |
Common
| Value | Count | Frequency (%) |
| 1730 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 69928 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| r | 8732 | 12.5% |
| a | 8607 | 12.3% |
| e | 7048 | 10.1% |
| s | 6801 | 9.7% |
| t | 3588 | 5.1% |
| p | 3582 | 5.1% |
| i | 3387 | 4.8% |
| O | 1904 | 2.7% |
| h | 1904 | 2.7% |
| R | 1852 | 2.6% |
| Other values (13) | 22523 |
customer_location
Categorical
HIGH CORRELATION
| Distinct | 10 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 69.1 KiB |
| Pune | |
|---|---|
| Jaipur | |
| Mumbai | |
| Delhi | |
| Hyderabad | |
| Other values (5) |
Length
| Max length | 9 |
|---|---|
| Median length | 7 |
| Mean length | 6.7321853 |
| Min length | 4 |
Characters and Unicode
| Total characters | 59425 |
|---|---|
| Distinct characters | 29 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Kolkata |
|---|---|
| 2nd row | Kolkata |
| 3rd row | Kolkata |
| 4th row | Kolkata |
| 5th row | Kolkata |
Common Values
| Value | Count | Frequency (%) |
| Pune | 1110 | |
| Jaipur | 1012 | |
| Mumbai | 954 | |
| Delhi | 922 | |
| Hyderabad | 910 | |
| Kolkata | 847 | |
| Lucknow | 804 | |
| Chennai | 790 | |
| Bangalore | 743 | |
| Ahmedabad | 735 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| pune | 1110 | |
| jaipur | 1012 | |
| mumbai | 954 | |
| delhi | 922 | |
| hyderabad | 910 | |
| kolkata | 847 | |
| lucknow | 804 | |
| chennai | 790 | |
| bangalore | 743 | |
| ahmedabad | 735 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 9226 | |
| e | 5210 | 8.8% |
| n | 4237 | 7.1% |
| u | 3880 | 6.5% |
| i | 3678 | 6.2% |
| d | 3290 | 5.5% |
| r | 2665 | 4.5% |
| b | 2599 | 4.4% |
| l | 2512 | 4.2% |
| h | 2447 | 4.1% |
| Other values (19) | 19681 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 50598 | |
| Uppercase Letter | 8827 | 14.9% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 9226 | |
| e | 5210 | |
| n | 4237 | 8.4% |
| u | 3880 | 7.7% |
| i | 3678 | 7.3% |
| d | 3290 | 6.5% |
| r | 2665 | 5.3% |
| b | 2599 | 5.1% |
| l | 2512 | 5.0% |
| h | 2447 | 4.8% |
| Other values (9) | 10854 |
Uppercase Letter
| Value | Count | Frequency (%) |
| P | 1110 | |
| J | 1012 | |
| M | 954 | |
| D | 922 | |
| H | 910 | |
| K | 847 | |
| L | 804 | |
| C | 790 | |
| B | 743 | |
| A | 735 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 59425 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 9226 | |
| e | 5210 | 8.8% |
| n | 4237 | 7.1% |
| u | 3880 | 6.5% |
| i | 3678 | 6.2% |
| d | 3290 | 5.5% |
| r | 2665 | 4.5% |
| b | 2599 | 4.4% |
| l | 2512 | 4.2% |
| h | 2447 | 4.1% |
| Other values (19) | 19681 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 59425 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 9226 | |
| e | 5210 | 8.8% |
| n | 4237 | 7.1% |
| u | 3880 | 6.5% |
| i | 3678 | 6.2% |
| d | 3290 | 5.5% |
| r | 2665 | 4.5% |
| b | 2599 | 4.4% |
| l | 2512 | 4.2% |
| h | 2447 | 4.1% |
| Other values (19) | 19681 |
merchant_name
Categorical
| Distinct | 18 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 69.1 KiB |
| airtel | |
|---|---|
| rakuten | |
| amazon | |
| amazon gift cards | |
| instamart | |
| Other values (13) |
Length
| Max length | 17 |
|---|---|
| Median length | 15 |
| Mean length | 11.171859 |
| Min length | 6 |
Characters and Unicode
| Total characters | 98614 |
|---|---|
| Distinct characters | 32 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | airtel |
|---|---|
| 2nd row | fake_merchant_2 |
| 3rd row | rakuten |
| 4th row | rakuten |
| 5th row | instamart |
Common Values
| Value | Count | Frequency (%) |
| airtel | 664 | 7.5% |
| rakuten | 660 | 7.5% |
| amazon | 657 | 7.4% |
| amazon gift cards | 636 | 7.2% |
| instamart | 628 | 7.1% |
| zomato | 625 | 7.1% |
| swiggy | 614 | 7.0% |
| chai talks | 595 | 6.7% |
| fake_merchant_5 | 394 | 4.5% |
| fake_merchant_6 | 393 | 4.5% |
| Other values (8) | 2961 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| amazon | 1293 | 12.1% |
| airtel | 664 | 6.2% |
| rakuten | 660 | 6.2% |
| gift | 636 | 5.9% |
| cards | 636 | 5.9% |
| instamart | 628 | 5.9% |
| zomato | 625 | 5.8% |
| swiggy | 614 | 5.7% |
| chai | 595 | 5.6% |
| talks | 595 | 5.6% |
| Other values (10) | 3748 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 15113 | |
| e | 8820 | 8.9% |
| t | 8184 | 8.3% |
| _ | 7496 | 7.6% |
| r | 6336 | 6.4% |
| n | 6329 | 6.4% |
| m | 6294 | 6.4% |
| k | 5003 | 5.1% |
| c | 4979 | 5.0% |
| f | 4384 | 4.4% |
| Other values (22) | 25676 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 85503 | |
| Connector Punctuation | 7496 | 7.6% |
| Decimal Number | 3748 | 3.8% |
| Space Separator | 1867 | 1.9% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 15113 | |
| e | 8820 | |
| t | 8184 | |
| r | 6336 | |
| n | 6329 | |
| m | 6294 | |
| k | 5003 | 5.9% |
| c | 4979 | 5.8% |
| f | 4384 | 5.1% |
| h | 4343 | 5.1% |
| Other values (10) | 15718 |
Decimal Number
| Value | Count | Frequency (%) |
| 5 | 394 | |
| 6 | 393 | |
| 9 | 392 | |
| 8 | 391 | |
| 7 | 384 | |
| 0 | 373 | |
| 3 | 364 | |
| 2 | 355 | |
| 1 | 354 | |
| 4 | 348 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 7496 |
Space Separator
| Value | Count | Frequency (%) |
| 1867 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 85503 | |
| Common | 13111 | 13.3% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 15113 | |
| e | 8820 | |
| t | 8184 | |
| r | 6336 | |
| n | 6329 | |
| m | 6294 | |
| k | 5003 | 5.9% |
| c | 4979 | 5.8% |
| f | 4384 | 5.1% |
| h | 4343 | 5.1% |
| Other values (10) | 15718 |
Common
| Value | Count | Frequency (%) |
| _ | 7496 | |
| 1867 | 14.2% | |
| 5 | 394 | 3.0% |
| 6 | 393 | 3.0% |
| 9 | 392 | 3.0% |
| 8 | 391 | 3.0% |
| 7 | 384 | 2.9% |
| 0 | 373 | 2.8% |
| 3 | 364 | 2.8% |
| 2 | 355 | 2.7% |
| Other values (2) | 702 | 5.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 98614 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 15113 | |
| e | 8820 | 8.9% |
| t | 8184 | 8.3% |
| _ | 7496 | 7.6% |
| r | 6336 | 6.4% |
| n | 6329 | 6.4% |
| m | 6294 | 6.4% |
| k | 5003 | 5.1% |
| c | 4979 | 5.0% |
| f | 4384 | 4.4% |
| Other values (22) | 25676 |
merchant_location
Categorical
| Distinct | 20 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 69.1 KiB |
| Paris, France | 495 |
|---|---|
| Tokyo, Japan | 483 |
| Bangalore | 480 |
| Kolkata | 465 |
| Delhi | 463 |
| Other values (15) |
Length
| Max length | 23 |
|---|---|
| Median length | 17 |
| Mean length | 11.390506 |
| Min length | 4 |
Characters and Unicode
| Total characters | 100544 |
|---|---|
| Distinct characters | 42 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Bangalore |
|---|---|
| 2nd row | Chennai |
| 3rd row | Sydney, Australia |
| 4th row | Pune |
| 5th row | Bangalore |
Common Values
| Value | Count | Frequency (%) |
| Paris, France | 495 | 5.6% |
| Tokyo, Japan | 483 | 5.5% |
| Bangalore | 480 | 5.4% |
| Kolkata | 465 | 5.3% |
| Delhi | 463 | 5.2% |
| Lucknow | 453 | 5.1% |
| Pune | 443 | 5.0% |
| Ahmedabad | 439 | 5.0% |
| Singapore, Singapore | 438 | 5.0% |
| London, UK | 438 | 5.0% |
| Other values (10) | 4230 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| singapore | 876 | 5.5% |
| paris | 495 | 3.1% |
| france | 495 | 3.1% |
| japan | 483 | 3.1% |
| tokyo | 483 | 3.1% |
| bangalore | 480 | 3.0% |
| kolkata | 465 | 2.9% |
| delhi | 463 | 2.9% |
| lucknow | 453 | 2.9% |
| pune | 443 | 2.8% |
| Other values (25) | 10666 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 11908 | 11.8% |
| o | 7483 | 7.4% |
| n | 7042 | 7.0% |
| 6975 | 6.9% | |
| e | 6164 | 6.1% |
| i | 6089 | 6.1% |
| r | 5729 | 5.7% |
| , | 4411 | 4.4% |
| d | 3411 | 3.4% |
| u | 3019 | 3.0% |
| Other values (32) | 38313 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 71604 | |
| Uppercase Letter | 17554 | 17.5% |
| Space Separator | 6975 | 6.9% |
| Other Punctuation | 4411 | 4.4% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 11908 | |
| o | 7483 | |
| n | 7042 | |
| e | 6164 | 8.6% |
| i | 6089 | 8.5% |
| r | 5729 | 8.0% |
| d | 3411 | 4.8% |
| u | 3019 | 4.2% |
| l | 2262 | 3.2% |
| p | 2199 | 3.1% |
| Other values (12) | 16298 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 2160 | |
| A | 2157 | |
| C | 1687 | |
| J | 1329 | 7.6% |
| T | 1316 | 7.5% |
| U | 1308 | 7.5% |
| P | 938 | 5.3% |
| B | 906 | 5.2% |
| K | 903 | 5.1% |
| D | 897 | 5.1% |
| Other values (8) | 3953 |
Space Separator
| Value | Count | Frequency (%) |
| 6975 |
Other Punctuation
| Value | Count | Frequency (%) |
| , | 4411 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 89158 | |
| Common | 11386 | 11.3% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 11908 | 13.4% |
| o | 7483 | 8.4% |
| n | 7042 | 7.9% |
| e | 6164 | 6.9% |
| i | 6089 | 6.8% |
| r | 5729 | 6.4% |
| d | 3411 | 3.8% |
| u | 3019 | 3.4% |
| l | 2262 | 2.5% |
| p | 2199 | 2.5% |
| Other values (30) | 33852 |
Common
| Value | Count | Frequency (%) |
| 6975 | ||
| , | 4411 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 100544 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 11908 | 11.8% |
| o | 7483 | 7.4% |
| n | 7042 | 7.0% |
| 6975 | 6.9% | |
| e | 6164 | 6.1% |
| i | 6089 | 6.1% |
| r | 5729 | 5.7% |
| , | 4411 | 4.4% |
| d | 3411 | 3.4% |
| u | 3019 | 3.0% |
| Other values (32) | 38313 |
trans_id
Text
UNIQUE
| Distinct | 8827 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 69.1 KiB |
Length
| Max length | 18 |
|---|---|
| Median length | 18 |
| Mean length | 18 |
| Min length | 18 |
Characters and Unicode
| Total characters | 158886 |
|---|---|
| Distinct characters | 62 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 8827 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | PvGyYAXFN5hE5HUzHy |
|---|---|
| 2nd row | wLovPGOet4ZLCiABkq |
| 3rd row | PnXTjxdEbojF3nY9Mn |
| 4th row | Lu6gvl9kDyu5N6MXkJ |
| 5th row | KEtEuTEBLBG53KLfF3 |
| Value | Count | Frequency (%) |
| pvgyyaxfn5he5huzhy | 1 | < 0.1% |
| i0zzpawzwh1ke8s5dr | 1 | < 0.1% |
| 4cjbll6f3gatlfnrrp | 1 | < 0.1% |
| ytkrwvnsnqc1ksevnu | 1 | < 0.1% |
| jw8habwcbcctypuoth | 1 | < 0.1% |
| l0ucneohu50yzybzzh | 1 | < 0.1% |
| tawmwfo65ya6b3oxnc | 1 | < 0.1% |
| 3lxth86xu1uwcvrd0e | 1 | < 0.1% |
| natou69ijuzbxzvte4 | 1 | < 0.1% |
| 3xzwihivrpsiyng3uz | 1 | < 0.1% |
| Other values (8817) | 8817 |
Most occurring characters
| Value | Count | Frequency (%) |
| Y | 2689 | 1.7% |
| 2 | 2658 | 1.7% |
| X | 2655 | 1.7% |
| i | 2641 | 1.7% |
| b | 2633 | 1.7% |
| g | 2631 | 1.7% |
| k | 2628 | 1.7% |
| 0 | 2622 | 1.7% |
| a | 2607 | 1.6% |
| f | 2606 | 1.6% |
| Other values (52) | 132516 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 66601 | |
| Lowercase Letter | 66560 | |
| Decimal Number | 25725 | 16.2% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| Y | 2689 | 4.0% |
| X | 2655 | 4.0% |
| J | 2605 | 3.9% |
| G | 2601 | 3.9% |
| L | 2599 | 3.9% |
| H | 2595 | 3.9% |
| W | 2589 | 3.9% |
| V | 2589 | 3.9% |
| U | 2587 | 3.9% |
| T | 2587 | 3.9% |
| Other values (16) | 40505 |
Lowercase Letter
| Value | Count | Frequency (%) |
| i | 2641 | 4.0% |
| b | 2633 | 4.0% |
| g | 2631 | 4.0% |
| k | 2628 | 3.9% |
| a | 2607 | 3.9% |
| f | 2606 | 3.9% |
| h | 2598 | 3.9% |
| r | 2591 | 3.9% |
| x | 2576 | 3.9% |
| s | 2570 | 3.9% |
| Other values (16) | 40479 |
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 2658 | |
| 0 | 2622 | |
| 3 | 2601 | |
| 5 | 2601 | |
| 4 | 2566 | |
| 8 | 2561 | |
| 6 | 2544 | |
| 1 | 2533 | |
| 9 | 2528 | |
| 7 | 2511 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 133161 | |
| Common | 25725 | 16.2% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| Y | 2689 | 2.0% |
| X | 2655 | 2.0% |
| i | 2641 | 2.0% |
| b | 2633 | 2.0% |
| g | 2631 | 2.0% |
| k | 2628 | 2.0% |
| a | 2607 | 2.0% |
| f | 2606 | 2.0% |
| J | 2605 | 2.0% |
| G | 2601 | 2.0% |
| Other values (42) | 106865 |
Common
| Value | Count | Frequency (%) |
| 2 | 2658 | |
| 0 | 2622 | |
| 3 | 2601 | |
| 5 | 2601 | |
| 4 | 2566 | |
| 8 | 2561 | |
| 6 | 2544 | |
| 1 | 2533 | |
| 9 | 2528 | |
| 7 | 2511 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 158886 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| Y | 2689 | 1.7% |
| 2 | 2658 | 1.7% |
| X | 2655 | 1.7% |
| i | 2641 | 1.7% |
| b | 2633 | 1.7% |
| g | 2631 | 1.7% |
| k | 2628 | 1.7% |
| 0 | 2622 | 1.7% |
| a | 2607 | 1.6% |
| f | 2606 | 1.6% |
| Other values (52) | 132516 |
UNIQUE
| Distinct | 8827 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 69.1 KiB |
Length
| Max length | 6 |
|---|---|
| Median length | 6 |
| Mean length | 6 |
| Min length | 6 |
Characters and Unicode
| Total characters | 52962 |
|---|---|
| Distinct characters | 36 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 8827 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | 7473NB |
|---|---|
| 2nd row | CFY0Y0 |
| 3rd row | NNEI38 |
| 4th row | G4TUYK |
| 5th row | ORLXBN |
| Value | Count | Frequency (%) |
| 7473nb | 1 | < 0.1% |
| inqlms | 1 | < 0.1% |
| 6bjs77 | 1 | < 0.1% |
| 13xdhr | 1 | < 0.1% |
| 5lccif | 1 | < 0.1% |
| h921k5 | 1 | < 0.1% |
| q8pysb | 1 | < 0.1% |
| 19f9qm | 1 | < 0.1% |
| w8tpxa | 1 | < 0.1% |
| 5oaaf9 | 1 | < 0.1% |
| Other values (8817) | 8817 |
Most occurring characters
| Value | Count | Frequency (%) |
| 8 | 1549 | 2.9% |
| P | 1548 | 2.9% |
| K | 1527 | 2.9% |
| 4 | 1513 | 2.9% |
| Q | 1512 | 2.9% |
| U | 1509 | 2.8% |
| F | 1508 | 2.8% |
| H | 1506 | 2.8% |
| V | 1504 | 2.8% |
| Z | 1496 | 2.8% |
| Other values (26) | 37790 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 38275 | |
| Decimal Number | 14687 | 27.7% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| P | 1548 | 4.0% |
| K | 1527 | 4.0% |
| Q | 1512 | 4.0% |
| U | 1509 | 3.9% |
| F | 1508 | 3.9% |
| H | 1506 | 3.9% |
| V | 1504 | 3.9% |
| Z | 1496 | 3.9% |
| T | 1492 | 3.9% |
| Y | 1487 | 3.9% |
| Other values (16) | 23186 |
Decimal Number
| Value | Count | Frequency (%) |
| 8 | 1549 | |
| 4 | 1513 | |
| 7 | 1494 | |
| 0 | 1492 | |
| 3 | 1455 | |
| 9 | 1451 | |
| 6 | 1447 | |
| 2 | 1440 | |
| 1 | 1434 | |
| 5 | 1412 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 38275 | |
| Common | 14687 | 27.7% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| P | 1548 | 4.0% |
| K | 1527 | 4.0% |
| Q | 1512 | 4.0% |
| U | 1509 | 3.9% |
| F | 1508 | 3.9% |
| H | 1506 | 3.9% |
| V | 1504 | 3.9% |
| Z | 1496 | 3.9% |
| T | 1492 | 3.9% |
| Y | 1487 | 3.9% |
| Other values (16) | 23186 |
Common
| Value | Count | Frequency (%) |
| 8 | 1549 | |
| 4 | 1513 | |
| 7 | 1494 | |
| 0 | 1492 | |
| 3 | 1455 | |
| 9 | 1451 | |
| 6 | 1447 | |
| 2 | 1440 | |
| 1 | 1434 | |
| 5 | 1412 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 52962 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 8 | 1549 | 2.9% |
| P | 1548 | 2.9% |
| K | 1527 | 2.9% |
| 4 | 1513 | 2.9% |
| Q | 1512 | 2.9% |
| U | 1509 | 2.8% |
| F | 1508 | 2.8% |
| H | 1506 | 2.8% |
| V | 1504 | 2.8% |
| Z | 1496 | 2.8% |
| Other values (26) | 37790 |
trans_loc
Categorical
HIGH CORRELATION
| Distinct | 10 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 69.1 KiB |
| Pune | |
|---|---|
| Jaipur | |
| Mumbai | |
| Delhi | |
| Hyderabad | |
| Other values (5) |
Length
| Max length | 9 |
|---|---|
| Median length | 7 |
| Mean length | 6.7321853 |
| Min length | 4 |
Characters and Unicode
| Total characters | 59425 |
|---|---|
| Distinct characters | 29 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Kolkata |
|---|---|
| 2nd row | Kolkata |
| 3rd row | Kolkata |
| 4th row | Kolkata |
| 5th row | Kolkata |
Common Values
| Value | Count | Frequency (%) |
| Pune | 1110 | |
| Jaipur | 1012 | |
| Mumbai | 954 | |
| Delhi | 922 | |
| Hyderabad | 910 | |
| Kolkata | 847 | |
| Lucknow | 804 | |
| Chennai | 790 | |
| Bangalore | 743 | |
| Ahmedabad | 735 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| pune | 1110 | |
| jaipur | 1012 | |
| mumbai | 954 | |
| delhi | 922 | |
| hyderabad | 910 | |
| kolkata | 847 | |
| lucknow | 804 | |
| chennai | 790 | |
| bangalore | 743 | |
| ahmedabad | 735 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 9226 | |
| e | 5210 | 8.8% |
| n | 4237 | 7.1% |
| u | 3880 | 6.5% |
| i | 3678 | 6.2% |
| d | 3290 | 5.5% |
| r | 2665 | 4.5% |
| b | 2599 | 4.4% |
| l | 2512 | 4.2% |
| h | 2447 | 4.1% |
| Other values (19) | 19681 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 50598 | |
| Uppercase Letter | 8827 | 14.9% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 9226 | |
| e | 5210 | |
| n | 4237 | 8.4% |
| u | 3880 | 7.7% |
| i | 3678 | 7.3% |
| d | 3290 | 6.5% |
| r | 2665 | 5.3% |
| b | 2599 | 5.1% |
| l | 2512 | 5.0% |
| h | 2447 | 4.8% |
| Other values (9) | 10854 |
Uppercase Letter
| Value | Count | Frequency (%) |
| P | 1110 | |
| J | 1012 | |
| M | 954 | |
| D | 922 | |
| H | 910 | |
| K | 847 | |
| L | 804 | |
| C | 790 | |
| B | 743 | |
| A | 735 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 59425 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 9226 | |
| e | 5210 | 8.8% |
| n | 4237 | 7.1% |
| u | 3880 | 6.5% |
| i | 3678 | 6.2% |
| d | 3290 | 5.5% |
| r | 2665 | 4.5% |
| b | 2599 | 4.4% |
| l | 2512 | 4.2% |
| h | 2447 | 4.1% |
| Other values (19) | 19681 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 59425 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 9226 | |
| e | 5210 | 8.8% |
| n | 4237 | 7.1% |
| u | 3880 | 6.5% |
| i | 3678 | 6.2% |
| d | 3290 | 5.5% |
| r | 2665 | 4.5% |
| b | 2599 | 4.4% |
| l | 2512 | 4.2% |
| h | 2447 | 4.1% |
| Other values (19) | 19681 |
trans_cat
Categorical
| Distinct | 7 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 69.1 KiB |
| Entertainment | |
|---|---|
| Travel | |
| Utilities | |
| Retail | |
| Grocery | |
| Other values (2) |
Length
| Max length | 13 |
|---|---|
| Median length | 9 |
| Mean length | 7.4611986 |
| Min length | 5 |
Characters and Unicode
| Total characters | 65860 |
|---|---|
| Distinct characters | 22 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Retail |
|---|---|
| 2nd row | Utilities |
| 3rd row | Utilities |
| 4th row | Retail |
| 5th row | Dining |
Common Values
| Value | Count | Frequency (%) |
| Entertainment | 1302 | |
| Travel | 1291 | |
| Utilities | 1260 | |
| Retail | 1246 | |
| Grocery | 1245 | |
| Dining | 1242 | |
| Other | 1241 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| entertainment | 1302 | |
| travel | 1291 | |
| utilities | 1260 | |
| retail | 1246 | |
| grocery | 1245 | |
| dining | 1242 | |
| other | 1241 |
Most occurring characters
| Value | Count | Frequency (%) |
| t | 8913 | |
| e | 8887 | |
| i | 8812 | |
| n | 6390 | |
| r | 6324 | |
| a | 3839 | 5.8% |
| l | 3797 | 5.8% |
| E | 1302 | 2.0% |
| m | 1302 | 2.0% |
| T | 1291 | 2.0% |
| Other values (12) | 15003 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 57033 | |
| Uppercase Letter | 8827 | 13.4% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| t | 8913 | |
| e | 8887 | |
| i | 8812 | |
| n | 6390 | |
| r | 6324 | |
| a | 3839 | |
| l | 3797 | |
| m | 1302 | 2.3% |
| v | 1291 | 2.3% |
| s | 1260 | 2.2% |
| Other values (5) | 6218 |
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 1302 | |
| T | 1291 | |
| U | 1260 | |
| R | 1246 | |
| G | 1245 | |
| D | 1242 | |
| O | 1241 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 65860 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| t | 8913 | |
| e | 8887 | |
| i | 8812 | |
| n | 6390 | |
| r | 6324 | |
| a | 3839 | 5.8% |
| l | 3797 | 5.8% |
| E | 1302 | 2.0% |
| m | 1302 | 2.0% |
| T | 1291 | 2.0% |
| Other values (12) | 15003 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 65860 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| t | 8913 | |
| e | 8887 | |
| i | 8812 | |
| n | 6390 | |
| r | 6324 | |
| a | 3839 | 5.8% |
| l | 3797 | 5.8% |
| E | 1302 | 2.0% |
| m | 1302 | 2.0% |
| T | 1291 | 2.0% |
| Other values (12) | 15003 |
trans_currency
Categorical
| Distinct | 7 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 69.1 KiB |
| INR | |
|---|---|
| CAD | |
| JPY | |
| USD | |
| AUD | |
| Other values (2) |
Length
| Max length | 5 |
|---|---|
| Median length | 3 |
| Mean length | 3.1411578 |
| Min length | 3 |
Characters and Unicode
| Total characters | 27727 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | INR |
|---|---|
| 2nd row | INR |
| 3rd row | AUD |
| 4th row | AUD |
| 5th row | INR |
Common Values
| Value | Count | Frequency (%) |
| INR | 5072 | |
| CAD | 648 | 7.3% |
| JPY | 643 | 7.3% |
| USD | 630 | 7.1% |
| AUD | 629 | 7.1% |
| Other | 623 | 7.1% |
| EUR | 582 | 6.6% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| inr | 5072 | |
| cad | 648 | 7.3% |
| jpy | 643 | 7.3% |
| usd | 630 | 7.1% |
| aud | 629 | 7.1% |
| other | 623 | 7.1% |
| eur | 582 | 6.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| R | 5654 | |
| I | 5072 | |
| N | 5072 | |
| D | 1907 | 6.9% |
| U | 1841 | 6.6% |
| A | 1277 | 4.6% |
| C | 648 | 2.3% |
| Y | 643 | 2.3% |
| P | 643 | 2.3% |
| J | 643 | 2.3% |
| Other values (7) | 4327 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 25235 | |
| Lowercase Letter | 2492 | 9.0% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| R | 5654 | |
| I | 5072 | |
| N | 5072 | |
| D | 1907 | 7.6% |
| U | 1841 | 7.3% |
| A | 1277 | 5.1% |
| C | 648 | 2.6% |
| Y | 643 | 2.5% |
| P | 643 | 2.5% |
| J | 643 | 2.5% |
| Other values (3) | 1835 | 7.3% |
Lowercase Letter
| Value | Count | Frequency (%) |
| t | 623 | |
| h | 623 | |
| e | 623 | |
| r | 623 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 27727 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| R | 5654 | |
| I | 5072 | |
| N | 5072 | |
| D | 1907 | 6.9% |
| U | 1841 | 6.6% |
| A | 1277 | 4.6% |
| C | 648 | 2.3% |
| Y | 643 | 2.3% |
| P | 643 | 2.3% |
| J | 643 | 2.3% |
| Other values (7) | 4327 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 27727 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| R | 5654 | |
| I | 5072 | |
| N | 5072 | |
| D | 1907 | 6.9% |
| U | 1841 | 6.6% |
| A | 1277 | 4.6% |
| C | 648 | 2.3% |
| Y | 643 | 2.3% |
| P | 643 | 2.3% |
| J | 643 | 2.3% |
| Other values (7) | 4327 |
mcc
Real number (ℝ)
| Distinct | 20 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4008.33 |
| Minimum | 4000 |
|---|---|
| Maximum | 4019 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 69.1 KiB |
Quantile statistics
| Minimum | 4000 |
|---|---|
| 5-th percentile | 4001 |
| Q1 | 4003 |
| median | 4008 |
| Q3 | 4013 |
| 95-th percentile | 4017 |
| Maximum | 4019 |
| Range | 19 |
| Interquartile range (IQR) | 10 |
Descriptive statistics
| Standard deviation | 5.4188039 |
|---|---|
| Coefficient of variation (CV) | 0.0013518857 |
| Kurtosis | -1.1792821 |
| Mean | 4008.33 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | 0.2204128 |
| Sum | 35381529 |
| Variance | 29.363435 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=20)
| Value | Count | Frequency (%) |
| 4005 | 832 | 9.4% |
| 4003 | 749 | 8.5% |
| 4001 | 734 | 8.3% |
| 4006 | 696 | 7.9% |
| 4014 | 680 | 7.7% |
| 4016 | 609 | 6.9% |
| 4009 | 597 | 6.8% |
| 4002 | 542 | 6.1% |
| 4010 | 522 | 5.9% |
| 4012 | 420 | 4.8% |
| Other values (10) | 2446 |
| Value | Count | Frequency (%) |
| 4000 | 272 | 3.1% |
| 4001 | 734 | |
| 4002 | 542 | |
| 4003 | 749 | |
| 4004 | 246 | 2.8% |
| 4005 | 832 | |
| 4006 | 696 | |
| 4007 | 139 | 1.6% |
| 4008 | 401 | |
| 4009 | 597 |
| Value | Count | Frequency (%) |
| 4019 | 156 | 1.8% |
| 4018 | 188 | 2.1% |
| 4017 | 291 | |
| 4016 | 609 | |
| 4015 | 172 | 1.9% |
| 4014 | 680 | |
| 4013 | 400 | |
| 4012 | 420 | |
| 4011 | 181 | 2.1% |
| 4010 | 522 |
trans_amount
Real number (ℝ)
| Distinct | 3502 |
|---|---|
| Distinct (%) | 39.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1028.0971 |
| Minimum | 1.04 |
|---|---|
| Maximum | 49890 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 69.1 KiB |
Quantile statistics
| Minimum | 1.04 |
|---|---|
| 5-th percentile | 4 |
| Q1 | 14.54 |
| median | 28 |
| Q3 | 41.730001 |
| 95-th percentile | 2719.105 |
| Maximum | 49890 |
| Range | 49888.96 |
| Interquartile range (IQR) | 27.190001 |
Descriptive statistics
| Standard deviation | 5431.5416 |
|---|---|
| Coefficient of variation (CV) | 5.2831016 |
| Kurtosis | 44.3273 |
| Mean | 1028.0971 |
| Median Absolute Deviation (MAD) | 13.6 |
| Skewness | 6.5483891 |
| Sum | 9075013.5 |
| Variance | 29501645 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 14 | 100 | 1.1% |
| 13 | 99 | 1.1% |
| 39 | 98 | 1.1% |
| 23 | 97 | 1.1% |
| 6 | 96 | 1.1% |
| 8 | 94 | 1.1% |
| 42 | 93 | 1.1% |
| 47 | 93 | 1.1% |
| 41 | 93 | 1.1% |
| 34 | 92 | 1.0% |
| Other values (3492) | 7872 |
| Value | Count | Frequency (%) |
| 1.039999962 | 1 | |
| 1.049999952 | 1 | |
| 1.070000052 | 1 | |
| 1.080000043 | 1 | |
| 1.090000033 | 1 | |
| 1.100000024 | 1 | |
| 1.120000005 | 2 | |
| 1.129999995 | 1 | |
| 1.159999967 | 1 | |
| 1.169999957 | 1 |
| Value | Count | Frequency (%) |
| 49890 | 1 | |
| 49592 | 1 | |
| 49246 | 1 | |
| 49087.94141 | 1 | |
| 49009.78125 | 1 | |
| 48734 | 1 | |
| 48496.19141 | 1 | |
| 48451.64062 | 1 | |
| 48443.44922 | 1 | |
| 48371 | 1 |
trans_date
Date
| Distinct | 8816 |
|---|---|
| Distinct (%) | 99.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 69.1 KiB |
| Minimum | 2023-08-10 06:34:19 |
|---|---|
| Maximum | 2023-09-09 06:16:29 |
Histogram with fixed size bins (bins=50)
trans_payment_method
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 69.1 KiB |
| Debit Card | |
|---|---|
| Credit Card |
Length
| Max length | 11 |
|---|---|
| Median length | 10 |
| Mean length | 10.494505 |
| Min length | 10 |
Characters and Unicode
| Total characters | 92635 |
|---|---|
| Distinct characters | 10 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Debit Card |
|---|---|
| 2nd row | Credit Card |
| 3rd row | Debit Card |
| 4th row | Debit Card |
| 5th row | Debit Card |
Common Values
| Value | Count | Frequency (%) |
| Debit Card | 4462 | |
| Credit Card | 4365 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| card | 8827 | |
| debit | 4462 | |
| credit | 4365 |
Most occurring characters
| Value | Count | Frequency (%) |
| C | 13192 | |
| r | 13192 | |
| d | 13192 | |
| e | 8827 | |
| i | 8827 | |
| t | 8827 | |
| 8827 | ||
| a | 8827 | |
| D | 4462 | 4.8% |
| b | 4462 | 4.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 66154 | |
| Uppercase Letter | 17654 | 19.1% |
| Space Separator | 8827 | 9.5% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| r | 13192 | |
| d | 13192 | |
| e | 8827 | |
| i | 8827 | |
| t | 8827 | |
| a | 8827 | |
| b | 4462 | 6.7% |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 13192 | |
| D | 4462 | 25.3% |
Space Separator
| Value | Count | Frequency (%) |
| 8827 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 83808 | |
| Common | 8827 | 9.5% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| C | 13192 | |
| r | 13192 | |
| d | 13192 | |
| e | 8827 | |
| i | 8827 | |
| t | 8827 | |
| a | 8827 | |
| D | 4462 | 5.3% |
| b | 4462 | 5.3% |
Common
| Value | Count | Frequency (%) |
| 8827 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 92635 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| C | 13192 | |
| r | 13192 | |
| d | 13192 | |
| e | 8827 | |
| i | 8827 | |
| t | 8827 | |
| 8827 | ||
| a | 8827 | |
| D | 4462 | 4.8% |
| b | 4462 | 4.8% |
trans_verify_method
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 69.1 KiB |
| PIN | |
|---|---|
| Biometric |
Length
| Max length | 9 |
|---|---|
| Median length | 3 |
| Mean length | 5.9792682 |
| Min length | 3 |
Characters and Unicode
| Total characters | 52779 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | PIN |
|---|---|
| 2nd row | Biometric |
| 3rd row | PIN |
| 4th row | Biometric |
| 5th row | Biometric |
Common Values
| Value | Count | Frequency (%) |
| PIN | 4444 | |
| Biometric | 4383 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| pin | 4444 | |
| biometric | 4383 |
Most occurring characters
| Value | Count | Frequency (%) |
| i | 8766 | |
| P | 4444 | |
| I | 4444 | |
| N | 4444 | |
| B | 4383 | |
| o | 4383 | |
| m | 4383 | |
| e | 4383 | |
| t | 4383 | |
| r | 4383 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 35064 | |
| Uppercase Letter | 17715 |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| i | 8766 | |
| o | 4383 | |
| m | 4383 | |
| e | 4383 | |
| t | 4383 | |
| r | 4383 | |
| c | 4383 |
Uppercase Letter
| Value | Count | Frequency (%) |
| P | 4444 | |
| I | 4444 | |
| N | 4444 | |
| B | 4383 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 52779 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| i | 8766 | |
| P | 4444 | |
| I | 4444 | |
| N | 4444 | |
| B | 4383 | |
| o | 4383 | |
| m | 4383 | |
| e | 4383 | |
| t | 4383 | |
| r | 4383 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 52779 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| i | 8766 | |
| P | 4444 | |
| I | 4444 | |
| N | 4444 | |
| B | 4383 | |
| o | 4383 | |
| m | 4383 | |
| e | 4383 | |
| t | 4383 | |
| r | 4383 |
trans_status
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 69.1 KiB |
| Payment | |
|---|---|
| Purchase | |
| Transfer |
Length
| Max length | 8 |
|---|---|
| Median length | 8 |
| Mean length | 7.6643254 |
| Min length | 7 |
Characters and Unicode
| Total characters | 67653 |
|---|---|
| Distinct characters | 14 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Transfer |
|---|---|
| 2nd row | Transfer |
| 3rd row | Payment |
| 4th row | Purchase |
| 5th row | Transfer |
Common Values
| Value | Count | Frequency (%) |
| Payment | 2963 | |
| Purchase | 2953 | |
| Transfer | 2911 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| payment | 2963 | |
| purchase | 2953 | |
| transfer | 2911 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 8827 | |
| e | 8827 | |
| r | 8775 | |
| P | 5916 | |
| n | 5874 | |
| s | 5864 | |
| y | 2963 | 4.4% |
| m | 2963 | 4.4% |
| t | 2963 | 4.4% |
| u | 2953 | 4.4% |
| Other values (4) | 11728 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 58826 | |
| Uppercase Letter | 8827 | 13.0% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 8827 | |
| e | 8827 | |
| r | 8775 | |
| n | 5874 | |
| s | 5864 | |
| y | 2963 | 5.0% |
| m | 2963 | 5.0% |
| t | 2963 | 5.0% |
| u | 2953 | 5.0% |
| c | 2953 | 5.0% |
| Other values (2) | 5864 |
Uppercase Letter
| Value | Count | Frequency (%) |
| P | 5916 | |
| T | 2911 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 67653 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 8827 | |
| e | 8827 | |
| r | 8775 | |
| P | 5916 | |
| n | 5874 | |
| s | 5864 | |
| y | 2963 | 4.4% |
| m | 2963 | 4.4% |
| t | 2963 | 4.4% |
| u | 2953 | 4.4% |
| Other values (4) | 11728 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 67653 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 8827 | |
| e | 8827 | |
| r | 8775 | |
| P | 5916 | |
| n | 5874 | |
| s | 5864 | |
| y | 2963 | 4.4% |
| m | 2963 | 4.4% |
| t | 2963 | 4.4% |
| u | 2953 | 4.4% |
| Other values (4) | 11728 |
fake
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 8.7 KiB |
| True | |
|---|---|
| False |
| Value | Count | Frequency (%) |
| True | 7581 | |
| False | 1246 | 14.1% |
| card_number | customer_age | mcc | trans_amount | customer_segment | card_type | customer_location | merchant_name | merchant_location | trans_loc | trans_cat | trans_currency | trans_payment_method | trans_verify_method | trans_status | fake | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| card_number | 1.000 | -0.001 | 0.007 | 0.002 | 0.972 | 0.972 | 0.972 | 0.000 | 0.042 | 0.972 | 0.000 | 0.000 | 0.000 | 0.000 | 0.062 | 0.000 |
| customer_age | -0.001 | 1.000 | 0.015 | 0.003 | 0.135 | 0.131 | 0.138 | 0.011 | 0.016 | 0.138 | 0.018 | 0.007 | 0.024 | 0.018 | 0.000 | 0.000 |
| mcc | 0.007 | 0.015 | 1.000 | 0.015 | 0.000 | 0.009 | 0.000 | 0.012 | 0.000 | 0.000 | 0.000 | 0.020 | 0.000 | 0.021 | 0.025 | 0.024 |
| trans_amount | 0.002 | 0.003 | 0.015 | 1.000 | 0.015 | 0.028 | 0.000 | 0.048 | 0.014 | 0.000 | 0.000 | 0.055 | 0.015 | 0.007 | 0.000 | 0.445 |
| customer_segment | 0.972 | 0.135 | 0.000 | 0.015 | 1.000 | 0.080 | 0.125 | 0.012 | 0.000 | 0.125 | 0.000 | 0.013 | 0.000 | 0.005 | 0.000 | 0.000 |
| card_type | 0.972 | 0.131 | 0.009 | 0.028 | 0.080 | 1.000 | 0.125 | 0.017 | 0.019 | 0.125 | 0.007 | 0.016 | 0.017 | 0.007 | 0.000 | 0.000 |
| customer_location | 0.972 | 0.138 | 0.000 | 0.000 | 0.125 | 0.125 | 1.000 | 0.000 | 0.000 | 1.000 | 0.001 | 0.000 | 0.007 | 0.020 | 0.000 | 0.000 |
| merchant_name | 0.000 | 0.011 | 0.012 | 0.048 | 0.012 | 0.017 | 0.000 | 1.000 | 0.000 | 0.000 | 0.014 | 0.053 | 0.000 | 0.018 | 0.000 | 0.347 |
| merchant_location | 0.042 | 0.016 | 0.000 | 0.014 | 0.000 | 0.019 | 0.000 | 0.000 | 1.000 | 0.000 | 0.000 | 0.016 | 0.000 | 0.000 | 0.000 | 0.021 |
| trans_loc | 0.972 | 0.138 | 0.000 | 0.000 | 0.125 | 0.125 | 1.000 | 0.000 | 0.000 | 1.000 | 0.001 | 0.000 | 0.007 | 0.020 | 0.000 | 0.000 |
| trans_cat | 0.000 | 0.018 | 0.000 | 0.000 | 0.000 | 0.007 | 0.001 | 0.014 | 0.000 | 0.001 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.016 |
| trans_currency | 0.000 | 0.007 | 0.020 | 0.055 | 0.013 | 0.016 | 0.000 | 0.053 | 0.016 | 0.000 | 0.000 | 1.000 | 0.006 | 0.000 | 0.000 | 0.348 |
| trans_payment_method | 0.000 | 0.024 | 0.000 | 0.015 | 0.000 | 0.017 | 0.007 | 0.000 | 0.000 | 0.007 | 0.000 | 0.006 | 1.000 | 0.000 | 0.011 | 0.000 |
| trans_verify_method | 0.000 | 0.018 | 0.021 | 0.007 | 0.005 | 0.007 | 0.020 | 0.018 | 0.000 | 0.020 | 0.000 | 0.000 | 0.000 | 1.000 | 0.019 | 0.000 |
| trans_status | 0.062 | 0.000 | 0.025 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.011 | 0.019 | 1.000 | 0.000 |
| fake | 0.000 | 0.000 | 0.024 | 0.445 | 0.000 | 0.000 | 0.000 | 0.347 | 0.021 | 0.000 | 0.016 | 0.348 | 0.000 | 0.000 | 0.000 | 1.000 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
| cardholder_name | card_number | customer_age | customer_segment | card_type | customer_location | merchant_name | merchant_location | trans_id | trans_approval_code | trans_loc | trans_cat | trans_currency | mcc | trans_amount | trans_date | trans_payment_method | trans_verify_method | trans_status | fake | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | Andrea Hess | 536174814465 | 61 | Premium | Other | Kolkata | airtel | Bangalore | PvGyYAXFN5hE5HUzHy | 7473NB | Kolkata | Retail | INR | 4002 | 1321.339966 | 2023-09-06 17:19:12 | Debit Card | PIN | Transfer | False |
| 1 | Andrea Hess | 536174814465 | 61 | Premium | Other | Kolkata | fake_merchant_2 | Chennai | wLovPGOet4ZLCiABkq | CFY0Y0 | Kolkata | Utilities | INR | 4003 | 19.340000 | 2023-09-06 17:19:48 | Credit Card | Biometric | Transfer | True |
| 2 | Andrea Hess | 536174814465 | 61 | Premium | Other | Kolkata | rakuten | Sydney, Australia | PnXTjxdEbojF3nY9Mn | NNEI38 | Kolkata | Utilities | AUD | 4001 | 30.730000 | 2023-09-06 17:20:33 | Debit Card | PIN | Payment | True |
| 3 | Andrea Hess | 536174814465 | 61 | Premium | Other | Kolkata | rakuten | Pune | Lu6gvl9kDyu5N6MXkJ | G4TUYK | Kolkata | Retail | AUD | 4011 | 15.000000 | 2023-09-06 17:21:03 | Debit Card | Biometric | Purchase | True |
| 4 | Andrea Hess | 536174814465 | 61 | Premium | Other | Kolkata | instamart | Bangalore | KEtEuTEBLBG53KLfF3 | ORLXBN | Kolkata | Dining | INR | 4019 | 49.599998 | 2023-09-06 17:21:47 | Debit Card | Biometric | Transfer | True |
| 5 | Andrea Hess | 536174814465 | 61 | Premium | Other | Kolkata | fake_merchant_8 | Lucknow | k9bTI7xbFA2EOKWO5a | M8RWCE | Kolkata | Grocery | INR | 4016 | 47.820000 | 2023-09-06 17:22:25 | Credit Card | Biometric | Payment | True |
| 6 | Andrea Hess | 536174814465 | 61 | Premium | Other | Kolkata | fake_merchant_9 | Rio de Janeiro, Brazil | 7FUAuqhisZeXyx4pPC | LIJU8K | Kolkata | Utilities | INR | 4001 | 42.340000 | 2023-09-06 17:23:14 | Credit Card | PIN | Transfer | True |
| 7 | Andrea Hess | 536174814465 | 61 | Premium | Other | Kolkata | airtel | Kolkata | i4wHRAbWOLSh80Nc0p | ABVYXQ | Kolkata | Grocery | INR | 4016 | 39.509998 | 2023-09-06 17:23:39 | Debit Card | PIN | Transfer | True |
| 8 | Andrea Hess | 536174814465 | 61 | Premium | Other | Kolkata | fake_merchant_1 | Dubai, UAE | az7mhtPnss2jhaAGsf | JCE9FV | Kolkata | Grocery | INR | 4010 | 10.000000 | 2023-09-06 17:24:23 | Debit Card | PIN | Purchase | True |
| 9 | Andrea Hess | 536174814465 | 61 | Premium | Other | Kolkata | fake_merchant_5 | Hyderabad | naToU69IjUzBxzvTE4 | W8TPXA | Kolkata | Entertainment | USD | 4017 | 34.000000 | 2023-09-06 17:25:06 | Credit Card | PIN | Payment | True |
| cardholder_name | card_number | customer_age | customer_segment | card_type | customer_location | merchant_name | merchant_location | trans_id | trans_approval_code | trans_loc | trans_cat | trans_currency | mcc | trans_amount | trans_date | trans_payment_method | trans_verify_method | trans_status | fake | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8817 | Brandy Smith | 071352436557 | 51 | Premium | Visa | Lucknow | rakuten | Dubai, UAE | kUtmsBbfkjt2mdmY1j | 53P4GY | Lucknow | Entertainment | INR | 4008 | 35.020000 | 2023-09-02 18:01:54 | Debit Card | Biometric | Purchase | True |
| 8818 | Brandy Smith | 071352436557 | 51 | Premium | Visa | Lucknow | swiggy | Paris, France | 179AvNBKjpxWWqT8Sa | IC8K91 | Lucknow | Utilities | Other | 4001 | 5.710000 | 2023-09-02 18:02:32 | Credit Card | PIN | Transfer | True |
| 8819 | Brandy Smith | 071352436557 | 51 | Premium | Visa | Lucknow | rakuten | Delhi | W3QU7qowt5bfjuu4Jb | KV1BHS | Lucknow | Travel | INR | 4017 | 11.000000 | 2023-09-02 18:03:20 | Debit Card | Biometric | Payment | True |
| 8820 | Brandy Smith | 071352436557 | 51 | Premium | Visa | Lucknow | chai talks | Lucknow | No1JwUQvM8rrnGxvV4 | 1FC4NE | Lucknow | Utilities | INR | 4014 | 46.470001 | 2023-09-02 18:03:42 | Debit Card | Biometric | Transfer | True |
| 8821 | Brandy Smith | 071352436557 | 51 | Premium | Visa | Lucknow | rakuten | Rio de Janeiro, Brazil | KhPMP6D5Oq2hw6rLxc | P7FQ8X | Lucknow | Entertainment | INR | 4008 | 45.759998 | 2023-09-02 18:04:32 | Credit Card | PIN | Payment | True |
| 8822 | Brandy Smith | 071352436557 | 51 | Premium | Visa | Lucknow | fake_merchant_9 | Bangalore | mpzQo2Uue0iBfB1Ary | XDLDML | Lucknow | Travel | INR | 4002 | 17.129999 | 2023-09-02 18:04:57 | Debit Card | Biometric | Purchase | True |
| 8823 | Brandy Smith | 071352436557 | 51 | Premium | Visa | Lucknow | fake_merchant_5 | Jaipur | PxTgSVW1mEckB2vLPn | X89TJW | Lucknow | Dining | USD | 4014 | 33.000000 | 2023-09-02 18:05:27 | Debit Card | PIN | Transfer | True |
| 8824 | Brandy Smith | 071352436557 | 51 | Premium | Visa | Lucknow | fake_merchant_8 | Jaipur | 5a3eoCHJQkJ15Oyxam | 2FT8TI | Lucknow | Travel | INR | 4016 | 32.000000 | 2023-09-02 18:06:09 | Credit Card | PIN | Transfer | True |
| 8825 | Brandy Smith | 071352436557 | 51 | Premium | Visa | Lucknow | fake_merchant_3 | Paris, France | 4vNzl86rhdWvGi2HX8 | KXCX3Q | Lucknow | Travel | JPY | 4003 | 18.000000 | 2023-09-02 18:06:51 | Debit Card | PIN | Transfer | True |
| 8826 | Brandy Smith | 071352436557 | 51 | Premium | Visa | Lucknow | airtel | Toronto, Canada | XiqAqPriIqmMg3rlbC | S97PD8 | Lucknow | Utilities | Other | 4019 | 14.000000 | 2023-09-02 18:07:16 | Debit Card | Biometric | Purchase | True |